SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535694 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535694 [ RunTime:0.001685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289959,908141,314970,517774,35562,1043914,127083,20613,753323,324913,759348,343244,568506,308375,185625,811883,260314,4936,641478,774971,606235,365052,439039,759315,815732,37075,1047174,1045669,690677,934144,761897,743521,870191,242593,102078,897331,624090,165709,867133,654038,379262,261192,190424,314211,596944,20695,184272,464123,297105,999520,414502,421742,460167,460291,311611,166474,143311,666076,89984,867086) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000931s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]