SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805791 LIMIT 1 [ RunTime:0.000812s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805791 [ RunTime:0.002446s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (697935,870409,1035390,128691,272080,388186,732295,507642,723174,352237,973774,848811,28866,22410,146328,587620,791464,22859,612422,22210,1008262,186990,433749,579595,906345,543519,342770,526734,631575,379883,174707,569514,712506,76614,765290,637367,297064,1024155,966127,388479,442837,474981,498987,750119,474095,726956,941611,266295,980839,305553,253824,605418,999059,885553,825797,482907,120071,885424,549230,20751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]