SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205411 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205411 [ RunTime:0.001582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (372040,774493,767117,785909,910849,992817,709054,35384,961296,363163,1009652,470173,216410,598790,497195,450368,633160,968911,831419,740835,456624,57922,975103,1020911,655632,801579,237891,64998,418938,312984,305554,300786,414304,826570,629390,172012,521673,859979,898671,917070,5134,870868,956218,899360,429455,379783,366554,254151,1001974,624488,885989,258528,101480,214669,632002,660660,103492,27415,683199,79521) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]