SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001692s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454809 LIMIT 1 [ RunTime:0.001244s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454809 [ RunTime:0.005193s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520122,527696,252984,359162,175317,721709,982680,940420,368146,711243,721930,673144,5466,853434,81080,553462,874405,303655,467232,152435,1006938,406483,690897,512871,938492,500193,805786,107478,845401,869957,771948,301077,1024165,874628,1020681,209165,433515,592443,167790,456876,495707,253644,187634,68707,576295,757632,929233,301348,808515,85649,311682,990002,549162,124657,26876,31024,670276,116543,778127,365940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000610s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]