SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003841s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284578 LIMIT 1 [ RunTime:0.004256s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284578 [ RunTime:0.001645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (237576,373001,853649,1002498,652224,761404,249503,706696,171887,234108,569368,346865,240257,217619,228410,798862,225622,134194,38839,926070,980903,649427,289212,467658,326314,909300,173506,1020072,640935,1012887,579938,202770,917727,1000685,166772,55282,124466,252789,22746,1008547,190052,45116,164185,654136,823287,463775,832696,473035,599842,622603,428432,904088,472319,109393,668416,398440,968322,866803,328634,167572) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284578 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284578 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]