SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 561811 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 561811 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422785,153888,440956,398138,166521,581176,716836,919001,993521,804204,990387,1026362,1027810,274207,18037,77331,395978,191462,933149,530864,664660,478671,780686,893240,735112,1003012,612022,849931,472000,1021248,486638,810538,480016,159267,97187,638864,560886,812107,208461,173707,646723,39369,17195,314018,657937,329018,62382,890502,42860,743468,712242,975770,769718,752128,75690,1012644,21269,981685,36749,407189) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 561811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 561811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001186s ]