SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283138 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283138 [ RunTime:0.003629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (889958,985785,61431,943733,526233,693360,347345,577070,199522,496940,122927,807604,689969,665487,281046,203618,288704,218940,762825,682264,35451,108644,1011995,441317,990514,337881,1035437,851018,1039035,565198,1029621,66647,383342,645765,794125,729069,251483,588657,370348,960859,909252,1020308,771069,173830,671050,750347,563693,210618,363591,369106,469589,808825,699674,659279,585151,70601,432936,90176,562347,634834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000628s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000680s ]