SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539238 LIMIT 1 [ RunTime:0.001128s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539238 [ RunTime:0.001509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (95728,883681,957934,787724,588085,512219,780117,30173,862588,334181,1014277,105109,110194,637005,990500,99098,594804,763715,1028404,454589,700544,183397,1001936,639796,132552,894038,470939,693487,756022,895279,861472,772659,992105,107263,736964,596871,592164,757661,300596,285684,712422,839050,802017,829032,795565,965439,374714,805625,1009678,620442,432834,477088,943333,294561,442774,916940,97484,182882,479024,710709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.020072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539238 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539238 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001405s ]