SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 993100 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 993100 [ RunTime:0.002590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (79988,520364,616513,919375,478080,381343,753002,691172,904693,385609,258008,729127,921979,907201,20499,383792,76810,684502,671396,455110,981874,189836,633724,57187,722844,565400,539613,495275,575397,601543,865836,41047,498593,644685,84353,838314,620235,937261,496952,462517,297787,832505,596210,80031,602169,529886,869819,370330,662801,412175,275253,999914,71142,38079,167360,912178,308590,771926,488556,683292) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 993100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 993100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]