SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511050 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511050 [ RunTime:0.002296s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (170119,283415,394154,713167,77594,195198,43779,602625,695938,648218,289623,122764,188025,650778,150203,912377,129549,822239,726590,869609,57399,977772,877956,525520,954625,713238,40851,71384,572665,489603,789997,311582,662383,468178,100314,199850,720621,1048072,181407,891976,164315,673365,499705,301945,898958,590681,382251,879726,470798,778640,285916,747584,250698,562322,733287,966918,410464,360357,46731,422619) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511050 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511050 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]