SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019997 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019997 [ RunTime:0.002090s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (394165,615342,18094,64480,730833,103881,255770,1023464,609875,602039,539579,368499,944414,685734,829117,946104,486967,978807,948055,838819,575580,809574,777842,571978,362195,536391,699181,414515,796127,585426,612748,159864,366463,78818,991004,375008,72345,297645,508045,834719,477986,761380,195136,647651,892961,753468,230298,470381,169839,626769,352116,832233,941224,754264,418625,973288,247808,151995,729811,419676) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019997 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019997 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]