SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 444421 LIMIT 1 [ RunTime:0.000634s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 444421 [ RunTime:0.006257s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (721308,701099,206282,736711,243764,1015849,989888,585570,446648,570972,916307,654152,840397,807574,860156,651622,782481,713191,1046778,439858,451019,985993,866152,643933,42071,548519,115057,977031,755815,247290,735153,342002,661380,882649,1011171,962345,808098,588314,4174,962296,284298,975544,514657,333731,251552,571074,403802,692151,301292,1014482,343679,491763,918762,928075,183498,140292,179770,518102,348817,19303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 444421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 444421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]