SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 389018 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 389018 [ RunTime:0.003411s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (757053,395815,739222,373859,12863,409133,571591,634987,719051,256650,220771,971208,827031,774414,179410,180559,761736,129140,651219,1000196,169341,729489,98715,42347,300848,617780,87951,200982,665850,499730,359592,539473,305289,767793,154579,474742,421070,793620,385052,239870,423749,541075,675428,926569,51388,180363,685219,752064,209382,891738,456449,32292,162117,907687,602157,90287,446067,431974,104911,513403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.025631s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 389018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 389018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001676s ]