SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310493 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310493 [ RunTime:0.001716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496211,848033,396882,597866,506657,875041,674795,685142,380254,24925,1011175,807439,666753,695281,532893,1026713,949379,587397,928570,280400,276188,1020551,720762,215534,836076,270985,998647,136592,66014,523886,737890,920476,1021021,379487,776723,770017,407220,776884,314251,248490,148808,950118,300987,942586,89935,803982,350606,356372,566241,141137,58874,279490,1013850,134730,998154,151576,726702,358444,723620,356700) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310493 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310493 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]