SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51138 LIMIT 1 [ RunTime:0.000561s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51138 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (826253,92950,514298,443402,319223,910840,236722,135041,470589,207571,970632,821621,124556,32869,897704,659783,315082,795146,310128,625203,29114,584288,747572,17319,738537,1046417,319670,846624,773345,110243,518592,804299,529119,673761,15773,811686,829050,613879,256718,679982,363265,768582,452798,894665,926046,262245,943331,546535,823873,166617,394687,251118,922469,136775,279235,383801,77331,850775,206607,862183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000653s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]