SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104305 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104305 [ RunTime:0.001494s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508577,1017592,1016008,1022745,523154,567743,486933,885986,643807,982021,594370,1037811,414132,228910,867459,762246,130911,181832,879184,278406,480998,197182,983717,555315,411373,370139,668130,455579,27052,487093,574700,141812,746856,249906,665156,204422,617238,14556,777493,692425,823745,249168,52320,352931,145759,836022,368571,512060,299213,156892,925859,314693,43703,585367,135698,724431,663999,719791,608959,853890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104305 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104305 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]