SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564986 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564986 [ RunTime:0.002333s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406621,683858,198526,16047,577672,756754,378072,480146,155908,876856,568712,890669,1038944,530724,19668,934173,785297,817127,837602,708476,578588,289294,810473,186530,276986,860370,811239,936420,881951,859850,484372,478170,617441,1027951,974232,554325,876531,292460,248345,113751,654382,395433,809976,752737,541756,217372,476891,551272,247895,149412,93042,91652,118423,746697,259563,428534,615335,862811,405345,127995) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564986 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564986 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]