SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565501 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565501 [ RunTime:0.001986s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (886130,878812,128991,671833,327959,150750,291863,686529,548306,181270,874521,224415,473269,248679,435353,318016,801495,958323,147121,600871,1022855,490448,166897,506566,457049,855654,388989,632007,888443,1048716,996296,773569,915088,649572,1037295,652250,566706,37382,112116,738604,542202,1003844,1013078,24229,956805,523065,174866,526734,895705,370707,451795,237459,241995,106088,667470,311824,716894,563278,433979,354120) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]