SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001910s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543620 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543620 [ RunTime:0.004702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (804200,194467,490153,946714,944871,689410,710437,705182,479880,388959,9111,490509,756377,709503,242421,777711,389320,489131,128710,285902,443705,368255,147702,480445,797836,919609,8971,810401,968903,948310,815385,671802,134783,198601,265222,249435,794389,254787,181158,1022018,780667,1036456,525131,28136,277661,831319,804168,291678,531450,1025067,438157,585612,842478,404241,412398,618205,618338,168371,640659,993064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543620 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000572s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543620 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]