SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405981 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405981 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570294,891233,222685,13881,790712,216338,833911,948871,874320,1045295,864552,121916,195661,944864,287970,162080,113338,320620,246318,53032,503313,636698,411094,79718,818500,553606,492232,732990,789662,304829,736834,622880,581946,443096,862619,36805,355621,46073,314711,173588,72075,726967,557401,566835,81778,943819,39595,806047,584015,722067,326919,798343,155471,85267,293097,301304,721487,979756,499280,416008) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]