SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002978s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 714850 LIMIT 1 [ RunTime:0.000807s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 714850 [ RunTime:0.004071s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (278116,859340,6361,946380,1031276,1019796,586102,414925,471095,974864,924113,118248,528368,359841,809218,400245,952772,821272,628426,871826,606700,126142,1010051,487466,679765,260361,568202,921484,1000100,906264,611911,485736,422208,83540,937138,803025,431470,881187,992424,144042,449680,565558,42223,428369,259939,652906,637626,213810,88533,619659,883452,560776,824940,931774,22244,12983,588317,14736,481185,657322) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 714850 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 714850 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]