SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001419s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 255281 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 255281 [ RunTime:0.005555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253620,689548,564182,823470,521263,353942,304162,508744,892044,142533,270992,903628,278359,110820,456795,630104,751676,83292,617806,917795,400013,948265,33976,58719,116889,712253,162611,76598,448755,1007376,176643,482582,762596,507247,901423,422290,44223,296367,1043568,969756,889173,764531,14154,169727,738481,862948,784617,584446,475879,654549,488211,780735,142432,316484,175122,527282,254146,104046,430335,398705) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001799s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 255281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000837s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 255281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001289s ]