SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001594s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111954 LIMIT 1 [ RunTime:0.000504s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111954 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (630048,573113,1021413,509399,191226,246996,968936,841244,181181,159809,225146,466768,499334,705325,569704,454595,729241,280628,344783,51375,995762,308446,528169,992247,588250,316976,948666,948716,495197,505002,901271,157016,184750,35613,89005,1000987,35214,776475,778374,849516,118752,790064,111995,902667,967784,584515,1031949,735104,864607,164629,264508,235803,537012,597341,111096,310819,352919,683362,984759,53038) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.019127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000760s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001121s ]