SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001538s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 375528 LIMIT 1 [ RunTime:0.000489s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 375528 [ RunTime:0.003478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508389,876086,746598,754079,341896,161339,857656,381682,960983,979260,735103,636027,289654,634816,204756,806503,144930,214410,763157,482319,831123,630204,307426,69971,946810,128867,335595,864537,552658,39752,499268,245409,706881,571689,274079,859980,967396,912647,846516,571006,227472,300032,539748,388556,465027,788636,318974,911114,768930,1010715,444243,376647,223142,731245,89423,274172,614738,1023776,58971,487845) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 375528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 375528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001154s ]