SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437216 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437216 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021455,372355,363695,324985,859121,369749,889429,288826,753808,264208,16474,879599,130106,586264,376523,528356,436032,137242,342666,12911,63207,923989,103218,522834,457170,828841,839817,546351,28953,961275,976048,1031777,977554,421268,956312,997142,721389,289417,364985,604431,824269,820287,890685,299610,297535,899107,78701,709044,571706,278890,730397,53118,844954,162796,209780,884853,825317,913707,327485,119367) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000399s ]