SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036310 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036310 [ RunTime:0.001433s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (14492,699365,62834,103958,318567,83354,491531,345616,514584,291408,871352,249635,121437,316319,194787,558988,497986,361269,939084,56647,832438,512346,805853,983957,552140,474182,219693,802721,513819,671351,328818,973657,261872,311132,325257,338000,307480,659308,635348,135132,276761,682449,703145,502513,899564,168439,189191,899134,437739,835745,1026947,779754,985350,145168,111969,132296,808598,726683,24239,369251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]