SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1008315 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1008315 [ RunTime:0.002417s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199953,620134,951676,393531,186202,362254,216955,983156,568714,78063,733249,276137,960907,628970,403656,384812,156614,357804,159769,700069,919480,889580,26722,357888,375839,963399,98568,852964,675055,207871,630509,1016724,755572,518375,606180,957785,104201,701548,14123,821998,515485,862044,729381,185059,521056,83941,141773,979413,358873,428339,761078,401380,816948,405669,723036,803613,736382,851105,742574,337966) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1008315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1008315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001142s ]