SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505003 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505003 [ RunTime:0.001799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435800,631624,417066,461379,702539,571369,957501,930287,590231,189733,944993,545568,225218,281074,344327,192302,295551,678735,702034,175905,135569,421700,139470,756527,178005,1058,698677,799154,905501,1037714,486742,857463,218214,910469,28613,791365,308954,1025831,844484,59848,442376,1044112,553413,768468,1047713,555432,511872,669832,527802,803129,732862,404795,380616,694600,176930,554715,633645,623067,899713,286787) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]