SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541219 LIMIT 1 [ RunTime:0.002201s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541219 [ RunTime:0.004518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (730211,979210,777214,779902,308128,663197,854599,491985,949676,341824,495922,3716,36092,1032634,315200,464743,18887,939071,487443,334123,224007,364389,854340,502859,788153,799510,953027,961437,957665,987659,341856,582119,25021,542698,426339,141112,733046,663140,364575,958049,59342,689822,460270,940150,16586,577635,558634,179766,579185,309623,98728,474311,436448,430229,831024,282151,1042572,193442,835177,166670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541219 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000677s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541219 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]