SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001480s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504661 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504661 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (972173,180698,491385,489840,562722,197594,327302,630062,1015113,620411,837603,531010,594869,307791,162627,598417,667325,384698,142940,957052,947291,761781,1029817,989259,821485,852386,473371,1016062,580080,303697,722124,583276,814525,796555,643879,270515,854120,755712,1040519,392603,22451,743853,118749,817897,257845,373490,609908,556816,266473,819857,845378,846886,820654,108722,424213,220664,1033116,329712,122650,78028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504661 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504661 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000797s ]