SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001556s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541133 LIMIT 1 [ RunTime:0.001050s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541133 [ RunTime:0.004910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400886,803211,693108,983577,1036776,106718,67779,876119,557941,872294,1023587,75442,144105,678641,423915,203509,449255,871485,395158,1029633,868378,712256,1032794,683219,18745,243206,754578,962708,618038,296017,717840,446521,306645,484330,33323,458384,126505,756875,912927,144497,676244,636373,246077,154542,165661,406609,744214,957810,377167,986776,679581,88470,402848,312,187297,58488,419124,203436,464454,471696) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541133 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541133 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]