SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541675 LIMIT 1 [ RunTime:0.000590s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541675 [ RunTime:0.002390s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (63792,312367,368178,1003272,211694,710623,714169,440249,55078,633413,694155,905431,190884,136950,558493,950249,694153,494273,740940,595029,638901,499393,312835,575241,1011799,90596,58031,989769,177381,326773,188582,26909,889182,568403,214643,543393,102954,148537,177562,224543,890843,519467,373922,470351,666720,108149,968620,1025088,162439,51756,678358,361200,584349,581942,368452,448368,260675,286855,140627,64668) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541675 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541675 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]