SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508273 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508273 [ RunTime:0.001924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486560,902984,532481,951147,851026,958454,196698,384550,1015617,113520,513503,1001261,409595,855137,810212,520539,979610,894882,1045795,564269,1018521,217329,308496,736260,525910,916510,621508,983898,296191,166333,515256,1034184,1013122,660559,971958,967520,304470,545443,146405,728404,892022,904806,194104,877016,827790,179783,19764,310379,59052,873370,877013,25605,1027415,248134,301822,251277,467622,871727,319774,609962) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001616s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508273 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508273 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]