SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 689209 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 689209 [ RunTime:0.001657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (960859,185739,678840,389143,470938,48757,546434,475287,643903,288303,332205,843551,83453,121993,400380,323159,640707,441154,66886,481516,165705,930042,933698,171535,979082,637889,54295,376487,311642,989330,150100,6618,352584,247461,127867,91934,359551,380415,225255,767700,946087,434611,98309,236288,81506,272007,727124,281430,707157,411862,482721,459121,125479,148456,377677,160638,76349,608511,438389,535268) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 689209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 689209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]