SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107501 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107501 [ RunTime:0.001969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (231440,9140,451241,775762,1004398,852002,561605,134776,71329,706243,709610,991055,919346,220043,534201,992398,757213,570800,262741,339879,602610,879464,60432,219627,17790,632245,157494,734336,592679,970069,249609,558174,696306,189412,190496,24055,824682,613455,1023968,312096,214738,508008,227520,949849,817239,587709,497672,695794,265431,894925,276645,433970,928613,1019350,83124,726376,1002396,84436,453140,946127) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]