SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 573648 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 573648 [ RunTime:0.001881s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (58384,738821,989610,167916,629131,417815,339805,189181,705106,1018973,712319,738476,233217,1038643,588533,73229,960931,701951,434747,511251,579204,260045,136232,60665,122265,245194,530017,618134,695428,377848,341883,863518,21556,966502,338163,304929,1039738,29212,749048,49143,270572,391504,854290,715354,676529,418362,622791,470647,443339,142806,362521,378972,574964,14137,1018401,654485,959451,870091,1040155,999404) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 573648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 573648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]