SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 298016 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 298016 [ RunTime:0.001884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (712654,469365,534038,425835,550867,780440,957497,751260,884508,302271,475981,227289,574394,574811,70250,696778,954543,608763,741671,563487,422268,613282,874562,786937,1044273,827350,607798,915612,942453,992820,609981,85781,593938,881070,866911,195187,113624,85887,932766,338437,1043702,254548,218305,362885,185289,451643,523292,577533,424019,908874,908408,757798,10660,677952,673314,267209,37010,225935,570328,644149) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 298016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 298016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000369s ]