SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028173 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028173 [ RunTime:0.001845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016038,739775,1028402,792987,279059,91192,590532,659866,112365,216193,716124,84445,322067,998805,263801,569108,153285,981668,584584,706363,835236,859091,906419,437854,56582,979387,313407,903848,35617,693872,113185,891377,285009,749744,396015,260710,311892,451427,493628,507128,53632,173845,650823,993250,170388,875265,296999,756242,706857,102171,835036,1026576,14957,753951,928026,880017,272320,117375,229806,875677) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028173 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028173 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]