SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420671 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420671 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530399,761199,85311,522096,539569,282774,861507,916839,342626,978908,128165,495121,743479,729270,467133,312212,652224,73659,678851,779892,714612,976821,941667,451901,378062,688494,249268,394737,358584,771686,1031917,959970,1011602,49078,602074,117829,810430,216029,391743,751457,466561,115840,600960,891467,644292,467387,142979,411351,180571,867528,1033210,701587,35460,40838,739371,391990,527124,846023,147267,957879) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]