SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469710 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469710 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320922,894604,345563,20003,801820,77643,54657,601218,330038,922498,611259,52943,30934,437388,845713,939374,441141,625038,852856,461401,1006611,689555,289819,163037,76533,294399,185634,546927,75789,268044,514335,937396,853499,955248,700114,534616,1048026,317124,206986,856235,553937,178489,71573,396993,916251,554786,1008035,368845,33255,816600,856093,461488,1043435,626203,326542,18765,104390,620874,11348,84744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]