SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001521s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291338 LIMIT 1 [ RunTime:0.000810s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291338 [ RunTime:0.001788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265648,673997,614437,103676,657726,996749,505807,821157,915872,181288,372115,350083,731886,314993,321900,765388,361607,704098,526399,965819,102834,452578,493107,83083,165113,538494,379473,573198,754271,1043574,947454,174303,591663,369384,980173,565973,708587,272351,950163,321091,742516,870803,391223,1023186,517963,450287,782676,971082,352663,173951,136780,421709,1035500,713957,25940,498676,131383,147787,452554,1037584) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291338 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291338 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]