SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 239613 LIMIT 1 [ RunTime:0.000941s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 239613 [ RunTime:0.002611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (610130,230584,821307,644603,909051,696639,990166,718212,653568,786228,342632,673633,317940,473254,461214,769861,471451,691074,632415,278580,570518,455462,382519,191217,882707,836782,712265,299780,38413,738798,1028492,594379,565560,548749,743386,506519,585421,968886,880991,13525,606656,1000114,746680,10528,215384,194381,529237,116010,977362,246981,168313,28480,181680,151767,558840,621780,683167,955674,831268,891446) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 239613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 239613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002231s ]