SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504206 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504206 [ RunTime:0.002032s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (361118,406602,129400,717734,165876,311,152876,474447,354392,339910,381521,435793,693652,631258,835098,790491,502318,1018389,896712,183781,689156,809800,362278,6552,252102,645957,20425,750466,105829,960949,918241,757342,195460,17494,63086,840134,562121,852256,772497,588672,915809,544439,878564,788854,498774,75069,382931,598874,1045298,366478,608378,1008215,867873,51769,393159,21129,1023101,922865,35875,160525) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504206 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504206 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002115s ]