SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401846 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401846 [ RunTime:0.004078s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (743234,246947,453581,166771,635299,967706,597250,844920,552862,378341,630510,441663,45741,114189,965704,1033579,1002171,997219,85298,665968,561396,549687,723750,107564,792458,507662,276604,419485,556945,100494,885868,274271,82609,1039585,39338,913378,735395,275080,419394,34496,431077,1010327,470816,763314,56007,785455,615747,421082,150246,581412,399771,906582,530205,482717,867175,28406,253062,436372,262574,776740) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401846 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401846 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]