SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510710 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510710 [ RunTime:0.002114s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249239,52414,75289,485388,481309,405581,185161,276538,969189,1045967,110328,353229,123330,507403,310944,638901,894635,683703,832094,509008,850118,639705,140202,400782,382459,564198,949770,872515,1044621,251760,982274,645406,171381,980359,262419,257927,1005877,14773,128655,344148,976568,495849,581518,188255,346268,587305,961997,469740,760007,388629,860067,15285,133848,456680,201749,1047978,473013,5080,461143,874481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]