SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001572s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038878 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038878 [ RunTime:0.002481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113280,1003814,278873,54147,567755,1011336,315998,751129,20323,1017554,637592,891808,68651,624566,874866,939430,425012,62930,298909,943069,91011,1022492,637538,194782,298039,174368,358271,795113,670146,253608,206160,686081,453312,963538,969569,816869,721801,526900,978610,325991,438746,437996,509684,777943,129295,22374,667977,978256,624959,887838,724047,592482,359212,242552,12386,512768,530705,1002834,910598,272893) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.017435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038878 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038878 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001454s ]