SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001983s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003586 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003586 [ RunTime:0.002270s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540149,65990,274402,26340,555684,309333,364528,189710,465679,993082,57503,849265,390144,722719,612526,141350,523124,799088,747234,672523,28266,366685,867770,257249,193111,27159,863373,388330,334635,76262,949908,68903,41746,449883,1008152,1091,257659,62412,601850,1015769,552982,354928,366765,419976,306063,241104,977308,703700,505714,338836,461189,890186,363105,544621,787969,604581,565229,527618,774334,713058) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003586 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003586 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000911s ]