SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417776 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417776 [ RunTime:0.002474s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046013,949472,901550,664803,460917,838212,641665,290992,828724,186627,362607,1015433,217909,605738,539983,439439,1018178,458782,241719,804863,497075,859971,9989,1012059,448256,885008,187098,7186,643082,358582,897234,591243,952641,445795,887001,1038919,635677,990420,661755,801361,857877,863408,128068,1047870,948524,891280,182273,559848,139015,634552,454972,685570,376260,979945,68582,656715,333859,901398,527120,151749) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417776 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417776 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]