SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 118522 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 118522 [ RunTime:0.001855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022368,443004,764428,357750,61136,890574,971252,355873,917138,786703,270561,208494,290160,189759,739474,399015,846481,366959,732072,952810,441907,123798,384409,1018246,932355,739494,68009,70731,879455,663173,991173,480086,1015697,174941,336217,986007,840678,788155,378537,873870,777358,44901,851213,309288,506736,332246,208514,22572,564004,591053,805135,684812,270427,1013412,638298,162444,685511,808630,781527,754943) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 118522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 118522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000762s ]