SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516011 LIMIT 1 [ RunTime:0.000535s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516011 [ RunTime:0.004902s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412121,49662,512317,160859,456978,109577,1004326,938492,350005,258445,955948,834913,341673,606521,879016,385163,257331,729643,903194,533640,274802,689188,18016,1028629,514518,1020677,171456,334047,199967,64649,682101,125093,445553,98511,132467,982802,36803,858265,618225,316304,8950,290636,306575,802335,1003093,804218,920959,196036,182659,397748,997777,590927,634652,461724,659673,159987,483856,889300,125237,40114) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002989s ]