SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331512 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331512 [ RunTime:0.001908s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (11620,483072,293094,829293,625105,75248,22973,115766,54319,570036,1006187,1018601,486863,9633,1038698,67218,637094,787384,374196,21729,409683,832621,837245,735161,643310,807713,222856,789963,145679,639147,258276,198313,760733,641600,654684,304373,179,148022,272730,118889,258083,863311,840677,995998,52123,50102,229732,963107,502987,57933,384092,120455,627927,34231,220191,58005,453716,1044137,179096,179700) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]