SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 588718 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 588718 [ RunTime:0.001744s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (975464,875843,435065,236103,380878,301512,886674,456050,800713,142430,507382,681521,885804,392211,167111,680919,171194,459852,132605,391613,991072,930218,890551,425272,84968,424151,347037,256740,820602,460699,22939,1042914,369569,814952,450636,994879,971912,479431,1034313,638431,167226,767541,751956,287111,444541,216936,941170,242210,485141,962184,653655,524129,243673,726505,834129,681545,363300,412901,980523,360822) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000940s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 588718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 588718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001684s ]