SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001509s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504538 LIMIT 1 [ RunTime:0.000486s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504538 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (99976,691133,733295,139453,890723,91097,438026,262946,463794,356781,547665,185860,442792,343724,528451,310890,947209,1013483,855775,721909,655435,445421,711217,367658,576871,6224,913792,445220,985698,683617,709558,746146,904282,927115,167848,214624,29476,487898,109272,839687,553950,737754,722850,195501,34513,843617,201889,287629,836120,803639,548755,42775,1039393,685264,590541,414921,252222,239513,808288,342779) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504538 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504538 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]