SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001508s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023592 LIMIT 1 [ RunTime:0.000800s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023592 [ RunTime:0.002248s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (225053,396112,149778,875081,655592,479961,418030,538785,302630,560439,451624,463755,589484,766190,415337,334225,963107,62761,719524,252810,162612,586479,1014325,329370,25847,624134,764770,619805,602751,28609,277285,300388,115802,630646,561070,225798,502836,332562,183204,255929,249593,119189,482779,125231,875908,734726,405952,360039,352439,631958,597199,395432,507675,542377,742034,357627,346792,104751,992478,166201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023592 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023592 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002549s ]