SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 309294 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 309294 [ RunTime:0.002928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356905,630936,1006364,415436,140852,315356,484151,112140,922049,702948,892768,447987,279250,38138,987017,796001,395680,73684,15637,131496,252362,505099,8805,422998,921775,575330,1044554,776365,104012,948046,322359,528,273185,394919,853314,991499,304035,53725,247706,608129,470140,381774,99916,998907,274998,87510,110318,804044,957718,13326,665158,42118,476831,752112,63153,535117,548749,432821,435850,24050) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 309294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 309294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]