SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104554 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104554 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (750453,299774,86210,1040030,542235,605742,84395,1004079,426544,503389,1030901,727344,790266,763342,771543,382516,185579,994406,735186,6948,213675,904246,150826,404981,10382,754441,468873,843626,843898,722055,122340,370569,931451,978045,311203,739587,737959,819337,104000,559707,533728,410423,681692,480092,975677,129648,320347,987981,684391,871551,227052,184514,701049,454291,307532,924798,452234,83879,900874,1033354) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104554 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104554 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]