SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584919 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584919 [ RunTime:0.002640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (309851,84147,355058,465263,274539,984798,100377,1001522,785490,515972,854456,328884,974540,339832,481185,162348,246886,911900,269127,7200,801306,794829,775678,711960,1013324,729501,509159,196732,689163,806906,388085,282257,362925,388296,802149,22195,54799,76559,783907,577212,713085,149030,659590,565206,869225,954205,1042665,70442,888501,620221,275300,504967,102484,1025695,377216,795659,880118,966996,126514,280893) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584919 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584919 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]