SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52620 LIMIT 1 [ RunTime:0.000727s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52620 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (207451,289977,674291,502640,783848,402489,583983,496859,117336,318988,788466,164310,868171,906708,329405,493462,242950,422840,168200,313096,515026,41164,387680,1018008,276552,940504,630669,211737,193789,75173,764323,906157,316969,25965,867959,379879,680796,781619,245403,257289,43121,813016,27821,730329,272857,812579,994043,644744,585648,181563,45052,83943,358016,396613,297280,957776,434666,330633,105985,251646) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012874s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52620 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52620 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001835s ]