SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540964 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540964 [ RunTime:0.001735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030650,752455,199998,728728,558830,782556,741385,774747,18170,224766,87952,121442,898487,717378,376463,553795,394866,216431,275485,900307,537984,889647,288022,678200,420369,898129,752099,644171,83653,846580,978550,726391,920537,344511,125579,474754,933475,26601,314844,424706,290578,643459,707826,693712,68896,654732,342360,160972,146661,184111,447062,308958,806344,619353,610898,703792,984187,297127,400208,445714) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540964 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540964 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000684s ]