SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001899s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 930514 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 930514 [ RunTime:0.001615s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (963518,1005774,401962,419177,538421,215565,274650,451384,522881,542856,1022443,394508,471885,605648,349622,744073,510585,149221,895581,106486,394809,801761,863994,325358,1025727,382485,488803,711695,1043820,165080,9994,135170,156588,697665,588913,925947,49132,396050,804230,347624,539140,698550,480377,853028,557812,719900,981983,732634,309715,1041202,274779,648239,629437,300341,44158,635060,387159,757416,15896,495813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 930514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 930514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]