SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514010 LIMIT 1 [ RunTime:0.000498s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514010 [ RunTime:0.004831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (56468,867846,944397,665600,964299,385673,623644,672453,508250,815743,811574,300458,843639,1019605,861019,412670,892317,377609,967694,908169,918179,389318,623159,980028,561611,56716,249512,102836,602815,863790,119294,963752,962205,911801,395310,919866,514289,813175,484321,296745,1001197,92721,522748,375258,254916,186870,1003421,387930,861540,437311,578032,220645,112458,355911,223421,774451,230844,923952,847190,2920) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000700s ]