SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461773 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461773 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580213,925596,70326,252794,23849,632844,349103,178673,1000878,621828,610329,431628,254088,619822,988962,741338,494586,335311,191723,28287,958635,21682,770161,187170,615045,800877,761001,681963,646709,530393,402415,928065,678749,387058,309449,658576,458697,32965,470114,867773,758517,162004,470867,1013832,188688,581114,315993,200638,165767,444202,73434,330810,745270,567805,136493,942714,774305,203126,428592,453327) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461773 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461773 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]