SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 667214 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 667214 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (984339,960197,78458,1014139,514429,47809,698242,341928,110838,806407,114258,305424,895633,562846,1021374,1013586,505606,433948,246940,407320,902643,320536,152950,409241,211831,598346,868686,365415,182430,1039893,361169,248096,185511,378841,88478,1043727,1047039,1047052,57238,310521,379414,931912,753524,916837,955519,431919,167661,982471,923269,17513,536269,399747,308063,723763,148330,271513,636687,135780,135528,141035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 667214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 667214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]