SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413513 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413513 [ RunTime:0.002555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201973,438136,507307,936967,80059,800196,550436,877360,24807,853514,517600,845249,287972,205103,106370,211463,228020,529996,225612,54450,514765,1012044,520730,382865,551186,647900,998011,173205,294375,858503,223373,545179,997081,532668,906049,11065,16540,72308,445042,471863,804198,630966,849209,938550,817331,458105,777038,104705,610604,422454,183569,114400,676333,444547,940066,30663,949623,462441,795770,46788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002246s ]