SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200697 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200697 [ RunTime:0.001884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (189217,915113,716386,15740,677697,944448,444551,884163,990491,1042533,531785,81523,806540,192919,559224,387328,156078,421575,30692,146414,950827,6969,348242,12015,44214,150776,939349,801268,688438,891266,948960,418177,1012830,955689,541084,781889,278074,502408,87727,188550,286500,836991,664338,296101,997006,860149,286746,86462,703906,782663,430149,305299,89704,819567,538123,56485,251085,392634,510777,593422) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200697 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200697 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001774s ]