SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557317 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557317 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433369,937021,933626,1004158,461862,989115,208134,399027,1035684,492781,369653,404989,650262,709749,433390,521684,3823,843826,838008,928274,170997,571418,560077,192845,972210,744614,774051,479671,526156,290185,787856,840259,552057,110536,322649,7550,740991,16018,540664,798296,470845,471213,429237,836753,725045,568942,669501,496610,4548,503639,768914,937413,382262,368330,214710,602255,109864,1000634,957836,552105) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003027s ]