SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 615610 LIMIT 1 [ RunTime:0.000638s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 615610 [ RunTime:0.003356s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (66780,670977,384070,1032974,445308,75139,590463,212613,588460,960319,609069,681018,806383,914848,49269,137941,558511,647507,740405,67138,751598,404489,307959,1029345,141785,916844,410400,673736,235225,282095,418736,333198,577236,617879,895564,1022942,812373,116453,414233,11723,913595,1025283,103581,230292,607148,426504,358218,338367,368391,416316,845399,190436,31396,891746,359413,30103,910804,600817,676595,399452) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 615610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 615610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000728s ]