SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10500 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10500 [ RunTime:0.001373s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342092,1036089,890507,506579,47938,736010,831475,561792,312640,228954,311986,81987,941671,17141,231297,375662,15430,377113,968002,997482,1034330,364622,516190,173270,184469,14007,739775,341942,714605,761895,469661,376676,332736,175006,770845,638247,305672,459429,891737,116471,916846,991632,270153,130788,309894,705507,848010,969895,1044471,784323,910444,972870,940165,1040232,856561,923236,842403,616521,556231,118917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]